Model Table SNAPSHOT
This model represents the human resouces dimension snapshot and is based on
the IFS Cloud dimension DIM_SNAPSHOT_DETAILS.
Attributes
| Attribute | Description (where applicable) |
| Snapshot Calendar | Snapshot category in source |
| Snapshot Calendar Id | Snapshot calender Id |
| Snapshot Category | Refered as Category_description in dimension |
| Snapshot Category Code | Refered as Code in dimension |
| Snapshot Period | Period for Snapshot |
| Snapshot Year | Year for Snapshot |
| Snapshot Year Period | Year and Period for Snapshot |
| Snapshot | Refered as CATEGORY_CALENDAR_YEAR_DESCR in dimension
(CATEGORY_DESCRIPTION + ' - ' + CALENDAR_DESCRIPTION + ' - ' + cast(YEAR
as varchar) + ' - ' + PERIOD as CATEGORY_CALENDAR_YEAR_DESCR). |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| SNAPSHOT | DIM_SNAPSHOT_DETAIL_TM | DIM_SNAPSHOT_DETAIL_BI | DIM_SNAPSHOT_DETAIL | On Line |